UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5QwlKKWwAtET91ZuaRn6wlJrSAiy4yXKF6Pyyb2Y3ek='
WHERE
key_id = 'fd4f31e5b02ef42a583cfa92ac70a0006c74017fe807acc1917e1dd543cc6681'
AND (
token = '5QwlKKWwAtET91ZuaRn6wlJrSAiy4yXKF6Pyyb2Y3ek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)