UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W1eQ4m5zAS2S9u1sPgPFau5m7MhDKGnzURZgFe+/VZI='
WHERE
key_id = '0538d94e069a3c855371187cb2e7c3c35ac5cf085b289586534d5049134c070a'
AND (
token = 'W1eQ4m5zAS2S9u1sPgPFau5m7MhDKGnzURZgFe+/VZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)