UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gQAetoGXr1hvZ4DzSxKMoL73sqIH1zBIcz3MwF0EiEc='
WHERE
key_id = '31ac6a74635f533e34b0c7cd49e29af13e9d02c3438b654c2fabff531d5882b3'
AND (
token = 'gQAetoGXr1hvZ4DzSxKMoL73sqIH1zBIcz3MwF0EiEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)