UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gkN1FJcJG13e4QN+77ZIAoy77Oi5bDRs3PjUkr/hJlk='
WHERE
key_id = '1f8b37e45637962f7f2e53ff24472931bcd5b77744db423647c4945388ae8533'
AND (
token = 'gkN1FJcJG13e4QN+77ZIAoy77Oi5bDRs3PjUkr/hJlk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)