UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3PJ7SJmlnHD1gyA1JZDEWlTOjEe07FnKjwB3iu/KEGs='
WHERE
key_id = '8df0bf40220c5243fb4d28d7a46b87354dd6b023446dd0483452af7e2676781e'
AND (
token = '3PJ7SJmlnHD1gyA1JZDEWlTOjEe07FnKjwB3iu/KEGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)