UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4J9Qmi3nsfpgkIMypei0e34lzlM/T1GRkGX3jiOCxl4='
WHERE
key_id = '379872ef5be68b613192e4ca8c8648cc03a9c6895da246841a7ef9235ac892f7'
AND (
token = '4J9Qmi3nsfpgkIMypei0e34lzlM/T1GRkGX3jiOCxl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)