UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L731wZ0hacNwE8zQoKDvjEae4hfYh29Lcfjyk8p0Zdw='
WHERE
key_id = '56577382e35669f3861d7dfc82b360a0327a2240f61e9326828928f60344cbb6'
AND (
token = 'L731wZ0hacNwE8zQoKDvjEae4hfYh29Lcfjyk8p0Zdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)