UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o79wGJb0ynqjtgwCJcYjSmYynF1wGqqdizaz3h4bkX0='
WHERE
key_id = '16a48979b0683564faf5a63d88dabe36e4c0f332505e9d64f5a9487e2368182d'
AND (
token = 'o79wGJb0ynqjtgwCJcYjSmYynF1wGqqdizaz3h4bkX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)