UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A3A6ZvD1kJ5MkDlCPCg4Wu3nVDiRRdai5qm8WNALI5w='
WHERE
key_id = 'e1e3e18e10e1dfad0f435670357af9200e3af591ea3a0b73981f6219de338478'
AND (
token = 'A3A6ZvD1kJ5MkDlCPCg4Wu3nVDiRRdai5qm8WNALI5w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)