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