UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F7Cz9X9WqdpvqEC3414rdx+2T8LEhptICAkzPhxP4rc='
WHERE
key_id = 'e6478f586d18ac624f392fc1eb4e95feca46d3041a16e7f1d126f19a052e6160'
AND (
token = 'F7Cz9X9WqdpvqEC3414rdx+2T8LEhptICAkzPhxP4rc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)