UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mh6I2jH1BdIs+b3fL6shMgBpHv4C6p9Is13VGNkzlLg='
WHERE
key_id = 'aef4b2f3c2ec9902cfa899090cba4ebd17974973befe15fc6dbfc42f432a14bc'
AND (
token = 'mh6I2jH1BdIs+b3fL6shMgBpHv4C6p9Is13VGNkzlLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)