UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CZBy6dBTk4k5VsMjzLfk9oUPNLnE3emme8g+4Ex1TGg='
WHERE
key_id = '01ac71dbdcbeb974f92e1fa1525a4d2506c90c659244c610ead85ae487a10a31'
AND (
token = 'CZBy6dBTk4k5VsMjzLfk9oUPNLnE3emme8g+4Ex1TGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)