UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K4CDPZ5eE9IyfgI3dBewS8gjUb2dzc6dTiTDDrr2s4I='
WHERE
key_id = '78dce1a749bdd0f9e1eccfbc1fe8e4f431e44019b8228f1481cafbfa04a4a71b'
AND (
token = 'K4CDPZ5eE9IyfgI3dBewS8gjUb2dzc6dTiTDDrr2s4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)