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