UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W18FMwJy15pB1k0IF4Os2y/nZanxT815kFOYmC9OOCs='
WHERE
key_id = 'a6725c91e5ec454ec7a321456c0e4a339275892d875a667e0d45e03879c71f05'
AND (
token = 'W18FMwJy15pB1k0IF4Os2y/nZanxT815kFOYmC9OOCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)