UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gPvdvNsYckN2ZU44MXS1o0vTGQrvF7JDuJ0Oi/x3HR8='
WHERE
key_id = 'd05e9b39df88735089a81dd3af73d3c19232c707f67d04c4cbf9c5fb7ea9dccb'
AND (
token = 'gPvdvNsYckN2ZU44MXS1o0vTGQrvF7JDuJ0Oi/x3HR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)