UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9aJc6IhbnjliLBfkMcnq0Xe5SvMoJuzhEZdgrVi5ILo='
WHERE
key_id = 'be1eaab166016cf779e1157a5fcd81e93032b8940ea1d0abc5ffcbf391747d92'
AND (
token = '9aJc6IhbnjliLBfkMcnq0Xe5SvMoJuzhEZdgrVi5ILo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)