UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i5rhfh2l11OS1CmBfQcC95UzdA62HR+/CZ+75YRqZ+Y='
WHERE
key_id = 'a167eb3e1a21fd372a9226194f7cf6c7f3a5eed98471f649a8d29a4f29dbc83b'
AND (
token = 'i5rhfh2l11OS1CmBfQcC95UzdA62HR+/CZ+75YRqZ+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)