UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LuS8dtvl3rFjU4C/35fIBWqCMuxw2663dMR8jRvGL8s='
WHERE
key_id = 'e217e12f627a0d350b74a05ad964934f0fb9016ca40b8005d3f52b9514adf71d'
AND (
token = 'LuS8dtvl3rFjU4C/35fIBWqCMuxw2663dMR8jRvGL8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)