UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XqP8BnroqeHjTa0PBWWnlUrYxQdpiwLW55zvnK1fTPg='
WHERE
key_id = '1b5f03b51bc99d45061d25533bbba7e8f497520db3d4028da9cd5431c5543dbd'
AND (
token = 'XqP8BnroqeHjTa0PBWWnlUrYxQdpiwLW55zvnK1fTPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)