UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '627tAwdCi3qUVpyaedKD4UyGwd8zEqh51BtzOpr3X7A='
WHERE
key_id = 'f14d022d7362d8e43dde55dd20b4f3b79fd1e6bfaad2ddc317afa4d163490cce'
AND (
token = '627tAwdCi3qUVpyaedKD4UyGwd8zEqh51BtzOpr3X7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)