UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XyVJfVd7ta9/8UhZdJ4752xrU/1h+unKvdwn+/8mdJg='
WHERE
key_id = 'e77aaf27d27c6638b23fa98dc4397920f51b11c1c44203a8d2a5f61617beb36f'
AND (
token = 'XyVJfVd7ta9/8UhZdJ4752xrU/1h+unKvdwn+/8mdJg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)