UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fnMBXfeRWMF6s5fApFetiSiaHY/CVTGEVBqa+z8V5r4='
WHERE
key_id = '1e47f2f35376da493edb10683fa749ae4ffdc1a1cbac852120d3d2551cff0778'
AND (
token = 'fnMBXfeRWMF6s5fApFetiSiaHY/CVTGEVBqa+z8V5r4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)