UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G56zcy+hD8DGRXRU1jXBNm6Mj47AUreJ0pr5aEgPNLU='
WHERE
key_id = 'f3800c6d84b8f4e913af5fe6120dd54bec6d842686a8c211fec2b648eecb1137'
AND (
token = 'G56zcy+hD8DGRXRU1jXBNm6Mj47AUreJ0pr5aEgPNLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)