UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S7KeScNfB6CM3eIsYl72OTd8rhs7y+7kCuRVjRd9o04='
WHERE
key_id = 'e030ede03abbc6229dba36dee84cd7a5bfbfc10d2395ba7f774876cc70fee97f'
AND (
token = 'S7KeScNfB6CM3eIsYl72OTd8rhs7y+7kCuRVjRd9o04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)