UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8GeFLPibHKyeYuFqOFiU4MsUHW/Vt77wlxhwKvqFv2Y='
WHERE
key_id = '1c0e201555f7e46398755be2df38e99e661aea8518c0376eaa6bb9fa35b7a718'
AND (
token = '8GeFLPibHKyeYuFqOFiU4MsUHW/Vt77wlxhwKvqFv2Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)