UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N/1WQ5X2JnebiI2NL0fV1acFTkkwXCbJf0Hec60MOvA='
WHERE
key_id = '6a49ce41a7bedc9e9243b6506b5e1c0b1b0e4000bbd78b638d2fea3729a43774'
AND (
token = 'N/1WQ5X2JnebiI2NL0fV1acFTkkwXCbJf0Hec60MOvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)