UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c59k+7oZEEur7DxycEwzk1KvqsF9W8LYo3y4wN1VINo='
WHERE
key_id = 'd99d228f894be82c6c3c783ea72d2b730b2394f5ca235f35cb9fba6331903267'
AND (
token = 'c59k+7oZEEur7DxycEwzk1KvqsF9W8LYo3y4wN1VINo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)