UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DEsKnLxHDyJ50mQUm+D5uc+ifIyMDPKX+MqTmB2hiwM='
WHERE
key_id = '2caf6acf343f644dc116fa243a7c957c6708a6b34aeffa4de89b50b0b087d0fd'
AND (
token = 'DEsKnLxHDyJ50mQUm+D5uc+ifIyMDPKX+MqTmB2hiwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)