UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZYn3hoBAyajixqiVO2PRFZc5QAhvNF2twX+nVCpDRsA='
WHERE
key_id = '08df392808fc9482fc116bcb23877be2177ba7fa6785273c9318703851ee2514'
AND (
token = 'ZYn3hoBAyajixqiVO2PRFZc5QAhvNF2twX+nVCpDRsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)