UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X6wtf305yVKkcux/302QLgqnjVSSjzyHYNv/4v0pydc='
WHERE
key_id = '78bb4e55dfd82153870ae11645444bcc7b4391e3c34adcecc5da32ffdcd9e89e'
AND (
token = 'X6wtf305yVKkcux/302QLgqnjVSSjzyHYNv/4v0pydc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)