UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RP9aJxx+MidsECfKlH4q2jQ14WZJQTs5DNMjVtN+eX4='
WHERE
key_id = '37e51fa46855daf333f400cc2f128f277eebfdd8eae10fb9a1783fbd78ae7a12'
AND (
token = 'RP9aJxx+MidsECfKlH4q2jQ14WZJQTs5DNMjVtN+eX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)