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