UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TfEMVFh0b5ugWDfT7OkypQPrAJlkNF/fsXiGsD8H354='
WHERE
key_id = 'b23dbb7458d79534d6ae6ad95fda807ab8f86945664138aedca5fd848077d2c8'
AND (
token = 'TfEMVFh0b5ugWDfT7OkypQPrAJlkNF/fsXiGsD8H354='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)