UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pSP9oSfT1kYMfgVL+33eVBPZJhuEAhjJZrEhhC8vNjk='
WHERE
key_id = '039d2384d752f577383d8d5e4bf9537f161211cc6691fed25c5fdb3246067fa6'
AND (
token = 'pSP9oSfT1kYMfgVL+33eVBPZJhuEAhjJZrEhhC8vNjk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)