UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yXcp6EigkV2ueLPc3rbS6YUUd2g+6SMNVsWvp8d8n5g='
WHERE
key_id = 'f471c54942cc174083aa2e8eb3f74e504f3e466370aac1df8921530745a39b0b'
AND (
token = 'yXcp6EigkV2ueLPc3rbS6YUUd2g+6SMNVsWvp8d8n5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)