UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'brTa61GWlmWVuU9kf7iwqw5bwKNZe6u0NgdiP6gQTw4='
WHERE
key_id = '0a7c29338600c05444e7b7579b114275dcd0148eaa736fa864121d632367abaa'
AND (
token = 'brTa61GWlmWVuU9kf7iwqw5bwKNZe6u0NgdiP6gQTw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)