UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ktOVm3E0keLwJBNHOSy1WL6zHjFWaBGwvL5gYS7Guk='
WHERE
key_id = '678231fb74e7761933c3075a6f628dc8832eadcd1c7585f3978b00d25be0d25c'
AND (
token = '9ktOVm3E0keLwJBNHOSy1WL6zHjFWaBGwvL5gYS7Guk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)