UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xNIva7NYdWC5kk0VeaJlmwRh1Bjuz2k+ir4s3q7Lye0='
WHERE
key_id = '592aa29451e03eb84b503d7647a24d1b1e51900bbedc1e0259120f6b15ef44f1'
AND (
token = 'xNIva7NYdWC5kk0VeaJlmwRh1Bjuz2k+ir4s3q7Lye0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)