UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BN/PQpO51bgGK3zofuVVxsX5+W9f2fSF2Nt6e0bfYhI='
WHERE
key_id = 'ebd91d45e2084e41c8563b1ad0eb256963445031dd4823e642c4d3c870c5c814'
AND (
token = 'BN/PQpO51bgGK3zofuVVxsX5+W9f2fSF2Nt6e0bfYhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)